When I read the HPI values from Quandl using df1=quandl.get("FMAC/HPI_AK", authtoken=authkey) and print df1.head, the first column has the name date whereas the second column does not have AK as the name and its name is displayed as "Value" When I try to merge HPI values from multiple states I am getting error ValueError: columns overlap but no suffix specified: Index(['Value'], dtype='object')
You must be logged in to post. Please login or register an account.
Got my answer. Just renamed the columns from Value to State name using
df=df.rename(columns = {'Value':str(abbv)})
-arvimahi4 7 years ago
You must be logged in to post. Please login or register an account.